Pagination Offset
dReveal's grid pagination control has been enhanced to improve performance and flexibility. A new pagination method, leveraging SQL OFFSET FETCH
clauses, has been introduced to calculate the total row count within a single query.
Override Hierarchy
The Pagination Offset configuration follows a cascading hierarchy. Each level overrides the settings from the previous level:
Report Definition (Outer Level): The Pagination Offset checkbox within the report definition holds the most granular control. Enabling it execution for that specific report.
Application Level: Programmatic configuration can override the report definition setting. This allows for adjustments based on specific application needs.
Server Level: The dReveal configuration on the server is the most global setting overriding any report definition or application-level configurations.